﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Student.Master" AutoEventWireup="true" CodeBehind="StudentSelScore.aspx.cs" Inherits="WebSystem.StudentSelScore" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <p style="text-align: left">
    <asp:HyperLink ID="HyperLink3" runat="server" NavigateUrl="~/StudentMain.aspx" Font-Size="Large">首页</asp:HyperLink>
    </p>
    <p style="text-align: left">
        <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; 
    </p>
    <p style="text-align: left">
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <asp:Label ID="lblInsNO" runat="server" Text="输入学号："></asp:Label>
&nbsp;
&nbsp;<asp:TextBox ID="txtNo1" runat="server"></asp:TextBox>
    &nbsp;&nbsp;&nbsp;&nbsp;<asp:Button ID="Button1" runat="server" Text="显示信息" OnClick="Button1_Click" style="position: relative; top: 2px; left: -31px; height: 21px" />
        &nbsp; &nbsp;&nbsp;&nbsp;
    </p>
    <p>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
    </p>
    <p>
        &nbsp;&nbsp; &nbsp;<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="Sno,Cno" DataSourceID="SqlDataSource1" style="text-align: center">
            <Columns>
                <asp:BoundField DataField="Sno" HeaderText="学号" ReadOnly="True" SortExpression="Sno" />
                <asp:BoundField DataField="Sname" HeaderText="姓名" SortExpression="Sname" />
                <asp:BoundField DataField="Cno" HeaderText="科目号" ReadOnly="True" SortExpression="Cno" />
                <asp:BoundField DataField="Cname" HeaderText="科目" SortExpression="Cname" />
                <asp:BoundField DataField="grade" HeaderText="成绩" SortExpression="grade" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014115121ConnectionString %>" SelectCommand="SELECT * FROM [Score] WHERE ([Sno] = @Sno)">
            <SelectParameters>
                <asp:ControlParameter ControlID="txtNo1" Name="Sno" PropertyName="Text" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
    </p>
    <p>
    </p>
    <p>
    </p>
    <p>
    </p>
</asp:Content>
